CSCI 0054. Visual Basic .NET Programming II
Units: 3
Prerequisite: Completion of CSCI 27 with grade of "C" or better
Hours: 72 (54 lecture, 18 laboratory)
Intermediate Visual Basic .NET programming. Includes coverage of multitier applications, database applications, databases using related tables, database updates, using Web forms, Web forms database and updates, XML Web services, and writing database reports using Crystal Reports. (CSU, UC)
CSCI 0054 - Visual Basic .NET Programming II
http://catalog.sierracollege.edu/course-outlines/csci-0054/
Catalog Description DESCRIPTION IS HERE: Prerequisite: Completion of CSCI 27 with grade of "C" or better Hours: 72 (54 lecture, 18 laboratory) Description: Intermediate Visual Basic .NET programming. Includes coverage of multitier applications, database applications, databases using related tables, database updates, using Web forms, Web forms database and updates, XML Web services, and writing database reports using Crystal Reports. (CSU, UC) Units 3 Lecture-Discussion 54 Laboratory 18 By Arrangement Contact Hours 72 Outside of Class Hours Course Student Learning Outcomes Create a test plan and program using Visual Basic.NET to provide a solution to a well defined programming program. Develop and use classes that have default properties, events, overloaded operators and inherited classes. Compare the different collection classes available in Visual Basic.NET. Use the Dataset Designer to 1) View the schema for the dataset of a data source; 2) Modify a query using Query Builder; 3) Preview the data for a query; 4) Review the SQL statements that are generated for a data source. Use a multiple-document interface (MDI) for an application that includes menus, toolbars and status bars. Course Content Outline I. Visual Studio .NET A. The .NET Framework B. Visual Studio .NET C. Helpful Hints for .NET II. Building Multitier Programs with Classes A. Object-Oriented Programming B. Creating Classes C. Namespaces, Scope, and Accessibility D. Passing Control Properties to a Component E. Garbage Collection III. Windows Database Applications A. Visual Basic and Database Applications B. MSDE and SQL Server C. Displaying Data in Individual Fields D. Multiple Tiers IV. Windows Database Using Related Tables A. Data Relationships B. Related Tables in a Grid C. Master/Detail Records D. Unbound Data Fields E. Many-to-Many Relationships V. Windows Database Updates A. The Data Objects B. Updating Data in a Grid C. The BindingContext Object D. Dataset Updating E. Updating a Dataset in Bound Controls F. Updating Related Tables VI. Using Web Forms - ASP.NET A. Web Applications B. Files in Web Projects C. Creating Web Forms D. Using the Validator Controls E. The IIS Application Objects F. State Management G. Managing Web projects VII. Web Forms Database A. Data Access in .NET B. Web Server DataGrid Controls C. The DataList Control D. More Controls E. Multiple Tiers F. Maintaining the State of List Boxes G. Controlling Validation VIII. Related Database Tables and Updates in Web Forms A. Displaying Data from Related Tables B. Updating a Database C. Multitier Considerations IX. Web Services A. Concepts and Terminology B. Creating a Web Service C. Consuming a Web Service D. Performing Calculations in a Web Service E. Accessing Data through a Web Service F. Moving a Web Service Project X. Writing Database Reports Using Crystal Reports A. Using Crystal Reports B. Creating and Displaying a Report Course Objectives Course Objectives Lecture Objectives: 1. Distinguish the features of the Visual Studio IDE versus the .NET Framework. 2. Identify the purpose of each of the files listed in the Solution Explorer. 3. Describe what happens at compile time. 4. Discuss features from the VB6 compatibility library and why you should avoid them. 5. Discuss object-oriented terminology. 6. Analyze the proper score for variables. 7. Explain the relationship of datasets, tables, rows, and constraints. 8. Use MSDE to access SQL Server databases. 9. Describe how to bind a grid, a combo box, and labels to a database field. 10. Explain the types of table relationships. 11. Describe how to display related tables using a DataGrid. 12. Summarize the procedure for retrieving and displaying data from more than two related tables. 13. Describe how to add, edit, and delete records in bound controls on a form. 14. Construct update statements to accurately update related tables. 15. Discuss concepts of Web-based applications. 16. Distinguish among the various types of button controls. 17. Describe the event structure used by Web applications. 18. Explain how to maintain state (data values) from one page to the next. 19. Determine when to use a data reader rather than a dataset. 20. Summarize how to display data in a Web DataGrid. 21. Explain how to edit, add, and delete records on Web Forms. 22. Determine whether to use bound or unbound fields. 23. Discuss the concept of a Web service. 24. Describe how to base a report on a data file or a dataset. 25. Explain how to display a report at run time based on a user request. Laboratory Objectives: 1. Create an MDI project with a parent form, child forms, a toolbar, status bar, context menu, and ToolTips. 2. Design your own class and instantiate objects based on the class. 3. Construct a new class based on an existing system class. 4. Create and throw custom exceptions. 5. Create and display information from a DataSet object. 6. Design a multitier application, separating the data tier from the presentation tier. 7. Create a program to retrieve and display the parent row for a selected child row. 8. Develop code that will display database fields in bound and unbound controls. 9. Modify a database table in a grid. 10. Use the form's binding context to navigate records. 11. Design an event handler and delegate for a component added in code. 12. Evaluate Web input using the Validator controls. 13. Create pagination for a grid. 14. Use the CheckboxList and RadioButtonList controls. 15. Construct a multitier Web application. 16. Construct a program to display data from related tables on a Web Form. 17. Create a Web service. 18. Design a program that consumes a Web service. 19. Construct a Web service that performs calculations. 20. Develop a Web service that accesses data. 21. Create a Crystal Reports template and display the report from a Windows Form or a Web Form. 22. Use advanced reporting functions, such as numeric functions, grouping, sorting, and special fields. Methods of Evaluation Essay Examinations Objective Examinations Problem Solving Examinations Projects Reports Reading Assignments 1. Students will read the assigned pages from the textbook and be prepared to discuss in class the use of databases in conjunction with Web Forms. 2. Students will read the assigned pages from the textbook and be prepared to discuss in class the use of Crystal Reports for generating database-driven reports. Writing, Problem Solving or Performance 1. Students will complete all of the Case Studies at the end of the chapter and test the retrieval of data through a Web Form to make sure that it works correctly. 2. Students will complete all of the Case Studies at the end of the chapter and generate reports that show customer information. Other (Term projects, research papers, portfolios, etc.) Methods of Instruction Laboratory Lecture/Discussion Distance Learning Other materials and-or supplies required of students that contribute to the cost of the course.
Course Identification Numbering System (C-ID)
...COMP 122 CSCI 0012 COMP 132 CSCI 0013...0056 AJ 140 ADMJ 0054 AJ 160 ADMJ...
